object ArizaGrupluRaporF: TArizaGrupluRaporF
  Left = 119
  Top = 49
  Width = 1010
  Height = 628
  Caption = 'Ar'#305'za Ayr'#305'nt'#305'l'#305' Rapor'
  Color = clBtnFace
  Font.Charset = TURKISH_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Arial'
  Font.Style = []
  FormStyle = fsMDIChild
  OldCreateOrder = False
  Position = poDefaultPosOnly
  Visible = True
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 14
  object Panel2: TPanel
    Left = 0
    Top = 568
    Width = 1002
    Height = 33
    Align = alBottom
    BevelOuter = bvNone
    Constraints.MinWidth = 600
    Font.Charset = TURKISH_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'Arial'
    Font.Style = []
    ParentFont = False
    TabOrder = 0
    DesignSize = (
      1002
      33)
    object pKapat: TPanel
      Left = 899
      Top = 0
      Width = 103
      Height = 33
      Align = alRight
      BevelOuter = bvNone
      TabOrder = 0
      object BitBtn5: TBitBtn
        Left = 23
        Top = 4
        Width = 75
        Height = 25
        Caption = 'Kapat'
        TabOrder = 0
        OnClick = BitBtn5Click
      end
    end
    object BitBtn1: TBitBtn
      Left = 8
      Top = 4
      Width = 89
      Height = 25
      Caption = 'Listele - F5'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 1
      OnClick = BitBtn1Click
    end
    object Button1: TButton
      Left = 718
      Top = 4
      Width = 90
      Height = 25
      Anchors = [akRight, akBottom]
      Caption = 'Export '#220'st Liste'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 2
      OnClick = Button1Click
    end
    object Button2: TButton
      Left = 814
      Top = 4
      Width = 87
      Height = 25
      Anchors = [akRight, akBottom]
      Caption = 'Export Alt Liste'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 3
      OnClick = Button2Click
    end
  end
  object Panel1: TPanel
    Left = 0
    Top = 0
    Width = 1002
    Height = 85
    Align = alTop
    BevelOuter = bvNone
    Font.Charset = TURKISH_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'Arial'
    Font.Style = []
    ParentFont = False
    TabOrder = 1
    object GroupBox1: TGroupBox
      Left = 176
      Top = 8
      Width = 161
      Height = 73
      Caption = 'Teknik Servis'
      TabOrder = 1
      object Label15: TLabel
        Left = 8
        Top = 24
        Width = 47
        Height = 14
        Caption = 'Ba'#351'.Tarihi'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        Transparent = True
      end
      object Label14: TLabel
        Left = 8
        Top = 48
        Width = 48
        Height = 14
        Caption = 'Biti'#351' Tarihi'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        Transparent = True
      end
      object TekBasTar: TwwDBDateTimePicker
        Left = 68
        Top = 16
        Width = 83
        Height = 22
        CalendarAttributes.Font.Charset = DEFAULT_CHARSET
        CalendarAttributes.Font.Color = clWindowText
        CalendarAttributes.Font.Height = -11
        CalendarAttributes.Font.Name = 'MS Sans Serif'
        CalendarAttributes.Font.Style = []
        Epoch = 1950
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        ShowButton = True
        TabOrder = 0
        UnboundDataType = wwDTEdtDate
        DisplayFormat = 'dd.mm.yyyy'
      end
      object TekBitTar: TwwDBDateTimePicker
        Left = 68
        Top = 40
        Width = 83
        Height = 22
        CalendarAttributes.Font.Charset = DEFAULT_CHARSET
        CalendarAttributes.Font.Color = clWindowText
        CalendarAttributes.Font.Height = -11
        CalendarAttributes.Font.Name = 'MS Sans Serif'
        CalendarAttributes.Font.Style = []
        Epoch = 1950
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        ShowButton = True
        TabOrder = 1
        DisplayFormat = 'dd.mm.yyyy'
      end
    end
    object GroupBox2: TGroupBox
      Left = 8
      Top = 8
      Width = 161
      Height = 73
      Caption = 'Sat'#305#351
      TabOrder = 0
      object Label1: TLabel
        Left = 8
        Top = 24
        Width = 47
        Height = 14
        Caption = 'Ba'#351'.Tarihi'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        Transparent = True
      end
      object Label2: TLabel
        Left = 8
        Top = 48
        Width = 48
        Height = 14
        Caption = 'Biti'#351' Tarihi'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        Transparent = True
      end
      object SatBasTar: TwwDBDateTimePicker
        Left = 68
        Top = 16
        Width = 83
        Height = 22
        CalendarAttributes.Font.Charset = DEFAULT_CHARSET
        CalendarAttributes.Font.Color = clWindowText
        CalendarAttributes.Font.Height = -11
        CalendarAttributes.Font.Name = 'MS Sans Serif'
        CalendarAttributes.Font.Style = []
        Epoch = 1950
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        ShowButton = True
        TabOrder = 0
        UnboundDataType = wwDTEdtDate
        DisplayFormat = 'dd.mm.yyyy'
      end
      object SatBitTar: TwwDBDateTimePicker
        Left = 68
        Top = 40
        Width = 83
        Height = 22
        CalendarAttributes.Font.Charset = DEFAULT_CHARSET
        CalendarAttributes.Font.Color = clWindowText
        CalendarAttributes.Font.Height = -11
        CalendarAttributes.Font.Name = 'MS Sans Serif'
        CalendarAttributes.Font.Style = []
        Epoch = 1950
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        ShowButton = True
        TabOrder = 1
        DisplayFormat = 'dd.mm.yyyy'
      end
    end
    object GroupBox3: TGroupBox
      Left = 344
      Top = 8
      Width = 201
      Height = 73
      TabOrder = 2
      object Label5: TLabel
        Left = 8
        Top = 24
        Width = 35
        Height = 14
        Caption = 'B'#246'l'#252'm'#252
      end
      object Label4: TLabel
        Left = 8
        Top = 48
        Width = 40
        Height = 14
        Caption = 'Stok Tipi'
      end
      object tipi: TwwDBLookupCombo
        Left = 56
        Top = 16
        Width = 136
        Height = 22
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        DisableThemes = False
        DropDownAlignment = taLeftJustify
        Selected.Strings = (
          'ttipi'#9'25'#9'ttipi'#9'F'
          'tkodu'#9'5'#9'tkodu'#9'F')
        LookupTable = Tekniktipi
        LookupField = 'tkodu'
        Options = [loColLines, loTitles]
        Color = clWhite
        Navigator = False
        ParentFont = False
        TabOrder = 0
        AutoDropDown = True
        ShowButton = True
        UseTFields = False
        AllowClearKey = True
        ShowMatchText = True
      end
      object StokTipic: TwwDBComboBox
        Left = 56
        Top = 40
        Width = 137
        Height = 22
        ShowButton = True
        Style = csDropDownList
        MapList = True
        AllowClearKey = False
        AutoDropDown = True
        DropDownCount = 8
        ItemHeight = 0
        Items.Strings = (
          'Stok Koduna G'#246're'#9'1'
          'Grup Koduna G'#246're'#9'2')
        Sorted = False
        TabOrder = 1
        UnboundDataType = wwDefault
      end
    end
    object GroupBox4: TGroupBox
      Left = 552
      Top = 8
      Width = 209
      Height = 73
      TabOrder = 3
      object Label6: TLabel
        Left = 8
        Top = 24
        Width = 71
        Height = 14
        Caption = 'De'#287'i'#351'im Durum'
      end
      object Label3: TLabel
        Left = 8
        Top = 48
        Width = 63
        Height = 14
        Caption = 'De'#287'i'#351'en Say'#305
      end
      object degisimdurumc: TwwDBComboBox
        Left = 88
        Top = 16
        Width = 113
        Height = 22
        ShowButton = True
        Style = csDropDownList
        MapList = True
        AllowClearKey = False
        AutoDropDown = True
        DropDownCount = 8
        ItemHeight = 0
        Items.Strings = (
          'De'#287'i'#351'enler'#9'1'
          'De'#287'i'#351'meyenler'#9'2')
        Sorted = False
        TabOrder = 0
        UnboundDataType = wwDefault
      end
      object GelenSayik: TEdit
        Left = 88
        Top = 40
        Width = 46
        Height = 21
        AutoSize = False
        TabOrder = 1
      end
    end
  end
  object Panel3: TPanel
    Left = 0
    Top = 85
    Width = 1002
    Height = 483
    Align = alClient
    BevelOuter = bvNone
    TabOrder = 2
    object cxgrid1: TcxGrid
      Left = 0
      Top = 0
      Width = 1002
      Height = 287
      Align = alClient
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 0
      LookAndFeel.Kind = lfUltraFlat
      LookAndFeel.NativeStyle = True
      object cxgrid1DBTableView1: TcxGridDBTableView
        OnDblClick = cxgrid1DBTableView1DblClick
        NavigatorButtons.ConfirmDelete = False
        DataController.DataSource = TeknikS
        DataController.DetailKeyFieldNames = 'FormNo'
        DataController.Filter.Active = True
        DataController.Filter.AutoDataSetFilter = True
        DataController.Options = [dcoAnsiSort, dcoAssignGroupingValues, dcoAssignMasterDetailKeys, dcoSaveExpanding]
        DataController.Summary.DefaultGroupSummaryItems = <
          item
            Format = 'Adet : #'
            Kind = skCount
            FieldName = 'StokKodu'
          end>
        DataController.Summary.FooterSummaryItems = <>
        DataController.Summary.SummaryGroups = <>
        OptionsBehavior.IncSearch = True
        OptionsData.CancelOnExit = False
        OptionsData.Deleting = False
        OptionsData.DeletingConfirmation = False
        OptionsData.Editing = False
        OptionsData.Inserting = False
        OptionsSelection.CellSelect = False
        OptionsSelection.UnselectFocusedRecordOnExit = False
        OptionsView.Indicator = True
        Styles.StyleSheet = dm.tvssDevExpress
        object cxgrid1DBTableView1formno: TcxGridDBColumn
          Caption = 'Form No'
          DataBinding.FieldName = 'formno'
        end
        object cxgrid1DBTableView1stokkodu: TcxGridDBColumn
          Caption = 'Stok Kodu'
          DataBinding.FieldName = 'stokkodu'
          Width = 100
        end
        object cxgrid1DBTableView1arizaturu: TcxGridDBColumn
          Caption = 'Ar'#305'za T'#252'r'#252
          DataBinding.FieldName = 'arizaturu'
          Width = 120
        end
        object cxgrid1DBTableView1yapilanislem: TcxGridDBColumn
          Caption = 'Yap'#305'lan '#304#351'lem'
          DataBinding.FieldName = 'yapilanislem'
          Width = 100
        end
        object cxgrid1DBTableView1tamireden: TcxGridDBColumn
          Caption = 'Tamir Eden'
          DataBinding.FieldName = 'tamireden'
          Width = 100
        end
        object cxgrid1DBTableView1degisenparca1: TcxGridDBColumn
          Caption = 'De'#287'i'#351'en Par'#231'a 1'
          DataBinding.FieldName = 'degisenparca1'
          SortIndex = 0
          SortOrder = soAscending
          Width = 120
        end
        object cxgrid1DBTableView1degisenparca2: TcxGridDBColumn
          Caption = 'De'#287'i'#351'en Par'#231'a 2'
          DataBinding.FieldName = 'degisenparca2'
          Width = 120
        end
        object cxgrid1DBTableView1degisenparca3: TcxGridDBColumn
          Caption = 'De'#287'i'#351'en Par'#231'a 3'
          DataBinding.FieldName = 'degisenparca3'
          Width = 120
        end
        object cxgrid1DBTableView1degisenparca4: TcxGridDBColumn
          Caption = 'De'#287'i'#351'en Par'#231'a 4'
          DataBinding.FieldName = 'degisenparca4'
          Width = 120
        end
        object cxgrid1DBTableView1degisenparca5: TcxGridDBColumn
          Caption = 'De'#287'i'#351'en Par'#231'a 5'
          DataBinding.FieldName = 'degisenparca5'
          Width = 120
        end
        object cxgrid1DBTableView1degisenparca6: TcxGridDBColumn
          Caption = 'De'#287'i'#351'en Par'#231'a 6'
          DataBinding.FieldName = 'degisenparca6'
          Width = 120
        end
        object cxgrid1DBTableView1degisenparca7: TcxGridDBColumn
          Caption = 'De'#287'i'#351'en Par'#231'a 7'
          DataBinding.FieldName = 'degisenparca7'
          Width = 120
        end
        object cxgrid1DBTableView1degisenparca8: TcxGridDBColumn
          Caption = 'De'#287'i'#351'en Par'#231'a 8'
          DataBinding.FieldName = 'degisenparca8'
          Width = 120
        end
        object cxgrid1DBTableView1degisenparca9: TcxGridDBColumn
          Caption = 'De'#287'i'#351'en Par'#231'a 9'
          DataBinding.FieldName = 'degisenparca9'
          Width = 120
        end
      end
      object cxgrid1BandedTableView1: TcxGridBandedTableView
        NavigatorButtons.ConfirmDelete = False
        DataController.Summary.DefaultGroupSummaryItems = <>
        DataController.Summary.FooterSummaryItems = <>
        DataController.Summary.SummaryGroups = <>
        Bands = <
          item
          end>
      end
      object cxgrid1Level1: TcxGridLevel
        GridView = cxgrid1DBTableView1
      end
    end
    object cxGrid2: TcxGrid
      Left = 0
      Top = 287
      Width = 1002
      Height = 196
      Align = alBottom
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 1
      LookAndFeel.Kind = lfUltraFlat
      LookAndFeel.NativeStyle = True
      object cxGridDBTableView1: TcxGridDBTableView
        NavigatorButtons.ConfirmDelete = False
        DataController.DataSource = GrupS
        DataController.DetailKeyFieldNames = 'FormNo'
        DataController.Filter.Active = True
        DataController.Filter.AutoDataSetFilter = True
        DataController.Options = [dcoAnsiSort, dcoAssignGroupingValues, dcoAssignMasterDetailKeys, dcoSaveExpanding]
        DataController.Summary.DefaultGroupSummaryItems = <
          item
            Format = 'Adet : #'
            Kind = skCount
            FieldName = 'StokKodu'
          end>
        DataController.Summary.FooterSummaryItems = <>
        DataController.Summary.SummaryGroups = <>
        OptionsBehavior.IncSearch = True
        OptionsData.CancelOnExit = False
        OptionsData.Deleting = False
        OptionsData.DeletingConfirmation = False
        OptionsData.Editing = False
        OptionsData.Inserting = False
        OptionsSelection.CellSelect = False
        OptionsSelection.UnselectFocusedRecordOnExit = False
        OptionsView.Indicator = True
        Styles.StyleSheet = dm.tvssDevExpress
        object cxGridDBTableView1grupbilgisi: TcxGridDBColumn
          Caption = 'Grup Bilgisi'
          DataBinding.FieldName = 'grupbilgisi'
          Width = 200
        end
        object cxGridDBTableView1adet: TcxGridDBColumn
          Caption = 'Adet'
          DataBinding.FieldName = 'adet'
          Width = 113
        end
      end
      object cxGridBandedTableView1: TcxGridBandedTableView
        NavigatorButtons.ConfirmDelete = False
        DataController.Summary.DefaultGroupSummaryItems = <>
        DataController.Summary.FooterSummaryItems = <>
        DataController.Summary.SummaryGroups = <>
        Bands = <
          item
          end>
      end
      object cxGridDBTableView2: TcxGridDBTableView
        NavigatorButtons.ConfirmDelete = False
        DataController.Summary.DefaultGroupSummaryItems = <>
        DataController.Summary.FooterSummaryItems = <>
        DataController.Summary.SummaryGroups = <>
      end
      object cxGridDBTableView3: TcxGridDBTableView
        NavigatorButtons.ConfirmDelete = False
        DataController.DataSource = TeknikS
        DataController.DetailKeyFieldNames = 'formno'
        DataController.KeyFieldNames = 'formno'
        DataController.MasterKeyFieldNames = 'FormNo'
        DataController.Summary.DefaultGroupSummaryItems = <>
        DataController.Summary.FooterSummaryItems = <>
        DataController.Summary.SummaryGroups = <>
        OptionsData.CancelOnExit = False
        OptionsData.Deleting = False
        OptionsData.DeletingConfirmation = False
        OptionsData.Editing = False
        OptionsData.Inserting = False
        object cxGridDBColumn15: TcxGridDBColumn
          Caption = 'Ar'#305'za Turu'
          DataBinding.FieldName = 'ArizaText'
          Width = 91
        end
        object cxGridDBColumn16: TcxGridDBColumn
          Caption = 'Par'#231'a De'#287'i'#351'imi'
          DataBinding.FieldName = 'StokCinsi'
          Width = 271
        end
        object cxGridDBColumn17: TcxGridDBColumn
          Caption = 'Montaj Durumu'
          DataBinding.FieldName = 'montajhatasi'
          Width = 53
        end
      end
      object cxGridDBTableView4: TcxGridDBTableView
        NavigatorButtons.ConfirmDelete = False
        DataController.Summary.DefaultGroupSummaryItems = <>
        DataController.Summary.FooterSummaryItems = <>
        DataController.Summary.SummaryGroups = <>
      end
      object cxGridLevel1: TcxGridLevel
        GridView = cxGridDBTableView1
      end
    end
    object ListBox1: TListBox
      Left = 360
      Top = 368
      Width = 121
      Height = 97
      ItemHeight = 14
      TabOrder = 2
      Visible = False
    end
    object ListBox2: TListBox
      Left = 504
      Top = 368
      Width = 121
      Height = 97
      ItemHeight = 14
      TabOrder = 3
      Visible = False
    end
  end
  object qryTeknik: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    CommandTimeout = 300
    Parameters = <>
    SQL.Strings = (
      'select formno, '
      '       dbo.getstokkodu(stokkod) as stokkodu,'
      
        '       arizaturu=(select Turu from ArizaTurleri p_s where p_s.id' +
        '=(select top 1 arizaturu from onarim where onarim.formno=teknik.' +
        'formno order by onarimno)),'
      
        '       yapilanislem=(select yapisturu from yapilanislem3 yap whe' +
        're yap.yapiskod=(select top 1 yapislemler from onarim where onar' +
        'im.formno=teknik.formno order by onarimno)),'
      
        '       tamireden=dbo.getpersonel((select top 1 tamireden from on' +
        'arim where onarim.formno=teknik.formno order by onarimno)),'
      
        '       degisenparca1=(select dbo.getstokkodu(ystokkod) from onar' +
        'im o where o.onarimno=(select top 1 onarimno from onarim where o' +
        'narim.formno=teknik.formno and ystokkod is not null order by ona' +
        'rimno)),'
      
        #9'   degisenparca2=(select dbo.getstokkodu(ystokkod) from onarim ' +
        'o where o.onarimno=(select min(onarimno) from onarim where onari' +
        'm.formno=teknik.formno and ystokkod is not null and onarimno not' +
        ' in (select top 1 onarimno from onarim where onarim.formno=tekni' +
        'k.formno and ystokkod is not null order by onarimno))),'
      
        #9'   degisenparca3=(select dbo.getstokkodu(ystokkod) from onarim ' +
        'o where o.onarimno=(select min(onarimno) from onarim where onari' +
        'm.formno=teknik.formno and ystokkod is not null and onarimno not' +
        ' in (select top 2 onarimno from onarim where onarim.formno=tekni' +
        'k.formno and ystokkod is not null order by onarimno))),'
      
        #9'   degisenparca4=(select dbo.getstokkodu(ystokkod) from onarim ' +
        'o where o.onarimno=(select min(onarimno) from onarim where onari' +
        'm.formno=teknik.formno and ystokkod is not null and onarimno not' +
        ' in (select top 3 onarimno from onarim where onarim.formno=tekni' +
        'k.formno and ystokkod is not null order by onarimno))),'
      
        #9'   degisenparca5=(select dbo.getstokkodu(ystokkod) from onarim ' +
        'o where o.onarimno=(select min(onarimno) from onarim where onari' +
        'm.formno=teknik.formno and ystokkod is not null and onarimno not' +
        ' in (select top 4 onarimno from onarim where onarim.formno=tekni' +
        'k.formno and ystokkod is not null order by onarimno))),'
      
        #9'   degisenparca6=(select dbo.getstokkodu(ystokkod) from onarim ' +
        'o where o.onarimno=(select min(onarimno) from onarim where onari' +
        'm.formno=teknik.formno and ystokkod is not null and onarimno not' +
        ' in (select top 5 onarimno from onarim where onarim.formno=tekni' +
        'k.formno and ystokkod is not null order by onarimno))),'
      
        #9'   degisenparca7=(select dbo.getstokkodu(ystokkod) from onarim ' +
        'o where o.onarimno=(select min(onarimno) from onarim where onari' +
        'm.formno=teknik.formno and ystokkod is not null and onarimno not' +
        ' in (select top 6 onarimno from onarim where onarim.formno=tekni' +
        'k.formno and ystokkod is not null order by onarimno))),'
      
        #9'   degisenparca8=(select dbo.getstokkodu(ystokkod) from onarim ' +
        'o where o.onarimno=(select min(onarimno) from onarim where onari' +
        'm.formno=teknik.formno and ystokkod is not null and onarimno not' +
        ' in (select top 7 onarimno from onarim where onarim.formno=tekni' +
        'k.formno and ystokkod is not null order by onarimno))),'
      
        #9'   degisenparca9=(select dbo.getstokkodu(ystokkod) from onarim ' +
        'o where o.onarimno=(select min(onarimno) from onarim where onari' +
        'm.formno=teknik.formno and ystokkod is not null and onarimno not' +
        ' in (select top 8 onarimno from onarim where onarim.formno=tekni' +
        'k.formno and ystokkod is not null order by onarimno)))'
      'from teknik'
      
        'where tarih>='#39'01.01.2007'#39' and tarih<='#39'31.01.2007'#39' and satistarih' +
        'i>='#39'01.01.2007'#39' and satistarihi<='#39'31.01.2007'#39' and tipi=1 and sub' +
        'eid=1 and carikodgir<>12810 and (durumu='#39'T'#39' or durumu='#39'G'#39')'
      
        'and (select top 1 onarimno from onarim where onarim.formno=tekni' +
        'k.formno and ystokkod is not null) is not null')
    Left = 824
    Top = 11
  end
  object TeknikS: TDataSource
    DataSet = qryTeknik
    Left = 776
    Top = 11
  end
  object Tekniktipi: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from tekniktipi')
    Left = 936
    Top = 8
  end
  object TekniktipiS: TDataSource
    DataSet = Tekniktipi
    Left = 880
    Top = 8
  end
  object GrupS: TDataSource
    DataSet = qryGrup
    Left = 784
    Top = 163
  end
  object qryGrup: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    CommandTimeout = 300
    Parameters = <>
    SQL.Strings = (
      
        'select stokkodu as grupbilgisi,cinsi as adet into #yeni from sto' +
        'k'
      'where stokkod=0'
      ''
      'Select * from #yeni'
      ''
      'drop table #yeni')
    Left = 832
    Top = 163
  end
end
